class EventsFieldsNotNull < ActiveRecord::Migration
  def self.up
    execute "ALTER TABLE `events` CHANGE `name` `name` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT ''"
    execute "ALTER TABLE `events` CHANGE `date` `date` DATETIME NOT NULL "
    execute "ALTER TABLE `events` CHANGE `country_id` `country_id` INT( 11 ) NOT NULL "
    execute "ALTER TABLE `events` CHANGE `region_id` `region_id` INT( 11 ) NOT NULL "
  end

  def self.down
  end
end
